Interview Questions

1. The view which returns the list of triggers in a database

Options:

a. sys.trigger

b. sys.triggers

c. sys.viewtriggers

d. None

Reveal Answer

2. The trigger that can be used on views is

Options:

a. After

b. For

c. Instead of

d. Before

Reveal Answer

3. How many INSTEAD OF triggers are allowed on a table or view?

Options:

a. Any number

b. 56

c. Only one

d. 10

Reveal Answer

4. To control the order of execution when multiple AFTER triggers are attached to sql table_____________ procedure is used.

Options:

a. sp_triggersetorder

b. sp_settriggerorder

c. sp_triggerorder

d. sp_triggerorderset

Reveal Answer

5. Trigger: create trigger tri_emp on employee After insert as select * from inserted Insert action: insert into employee values(1,'aryan','manager',20000,1) Which statement is true for the above example

Options:

a. The code in the trigger is executed first and after that the insert statement is executed and the record is inserted into the table.

b. The record is inserted into the database first and after that the trigger is fired and the code in the trigger is executed.

c. The record is not inserted into the database at all, instead the code in the trigger is executed

d. The insert statement is performed and the record is inserted in to the database, but the code in the trigger is not executed at allocated

Reveal Answer

6. Which of the following are similar triggers?

Options:

a. Instead of trigger

b. After triggers

c. For triggers

d. None of the above are similar

Reveal Answer

7. The code in the trigger can be executed by explicitly calling the trigger by its name

Options:

a. TRUE

b. FALSE

Reveal Answer

8. Which of the following are magic tables?

Options:

a. Delete table

b. Deleted table

c. Insert table

d. Inserted table

Reveal Answer

9. Inside a trigger if the following IF condition is true then what is the action that fired the trigger? if((select COUNT(*) from inserted)=0)

Options:

a. Inserted

b. Delete

c. Update

d. Create

Reveal Answer

10. Which trigger should be used to make possible un-updatable views work like updatable views

Options:

a. After

b. For

c. Instead of

d. None

Reveal Answer

11. Which statements are true regarding magic tables

Options:

a. Magic tables have to be created by the user explicitly while creating trigger itself

b. The span of magic tables is until the table on which they are created exists

c. The sql server creates the magic tables

d. The span of magic tables is until the execution of the trigger is completed.

Reveal Answer

12. Triggers get fired only when we perform these actions

Options:

a. Insert

b. Delete

c. Update

d. All the above

Reveal Answer

13. Maximum no:of triggers that can be attached to a table are

Options:

a. 10

b. no limit

c. 12

d. 24

Reveal Answer

14. Which statements are true regarding triggers

Options:

a. Does not accept arguments or parameters

b. can perform COMMIT and ROLLBACK in the trigger code

c. cyclic triggers should be avoided

d. Magic tables contain the new and old values of the data that initiated the trigger

Reveal Answer

15. create trigger tri_employee_uppernames on employee after insert as update employee set empname=upper(empname) where pkempno =(select pkempno from inserted) Now insert records into the employee table insert into employee values(33,'spandana','director',4000,2),(34,'padmaja','manager',8000,2), (35,'ravi','developer',9000,3) Which statement is true for the above example

Options:

a. The trigger gets created successfully

b. The insert statement is correct

c. The record is not inserted into the databases

d. The record is successfully inserted into the database

Reveal Answer

16. create trigger tri_empdemo_insert on empdemo after insert as if not exists(select pkdeptno from deptdemo where pkdeptno=(select fkdeptno from inserted)) begin raiserror('INVALIED DEPARTMENT NUMBER',11,1) rollback end Insert a record insert into empdemo values (19,'pradhan','administrator',35000,6) What is the output for the following example where '6' is the department number which is not an existing data in the department table.

Options:

a. The error message 'INVALIED DEPARTMENT NUMBER' will be displayed as the department doesnot exist, but still the record is inserted

b. The error message 'INVALIED DEPARTMENT NUMBER' will be displayed as the department doesnot exist, and the record is not inserted as the total transaction is rolled back

c. ROLLBACK is not a valid statement in triggers.

d. ROLLBACK will rollback all the executable statements above and also the insert action which fired the trigger

Reveal Answer

17. Trigger can be disabled

Options:

a. TRUE

b. FALSE

Reveal Answer

18. DDL triggers are always __________________ triggers

Options:

a. Instead of

b. After

Reveal Answer

19. which statement is true regarding triggers

Options:

a. Though there is a data modification logic within a trigger for which there is a trigger created, the trigger can not be fired from within a trigger

b. If there is a data modification logic within a trigger for which there is a trigger created, then the trigger can be fired from within a trigger

c. A trigger that contains data modification logic within itself is called a nested trigger.

d. Nested triggers are not allowed

Reveal Answer

20. If the path of triggers being fired is as follows Insert action--------> Trigger_1-------------->Trigger_2---------->Trigger_1 Then it is a

Options:

a. Only nested trigger

b. Nested cyclic trigger

c. Trigger which ends up in dead lock

d. None

Reveal Answer

Interview Questions and Answer

1. The view which returns the list of triggers in a database

2. The trigger that can be used on views is

3. How many INSTEAD OF triggers are allowed on a table or view?

4. To control the order of execution when multiple AFTER triggers are attached to sql table_____________ procedure is used.

5. Trigger: create trigger tri_emp on employee After insert as select * from inserted Insert action: insert into employee values(1,'aryan','manager',20000,1) Which statement is true for the above example

6. Which of the following are similar triggers?

7. The code in the trigger can be executed by explicitly calling the trigger by its name

8. Which of the following are magic tables?

9. Inside a trigger if the following IF condition is true then what is the action that fired the trigger? if((select COUNT(*) from inserted)=0)

10. Which trigger should be used to make possible un-updatable views work like updatable views

11. Which statements are true regarding magic tables

12. Triggers get fired only when we perform these actions

13. Maximum no:of triggers that can be attached to a table are

14. Which statements are true regarding triggers

17. Trigger can be disabled

18. DDL triggers are always __________________ triggers

19. which statement is true regarding triggers

20. If the path of triggers being fired is as follows Insert action--------> Trigger_1-------------->Trigger_2---------->Trigger_1 Then it is a

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources